home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Magnum One
/
Magnum One (Mid-American Digital) (Disc Manufacturing).iso
/
d13
/
q_aparad.arc
/
REPORTS.QA
< prev
next >
Wrap
Text File
|
1991-03-13
|
7KB
|
265 lines
PARADOX COMMON QUESTIONS AND ANSWERS
REPORTS
1. Why are my Page headers floating around on the page?
Floating headers are caused by page length inconsistencies
or end of page problems. Make sure your default printer
page length is the same as the set page length in Paradox.
ie. HP LaserJet Portrait mode should be set to 60 lines.
Also, set the end of page action: <M>ainmenu, <R>eport,
<S>etprinter, <O>verride, <E>ndOfPage, <F>ormfeed.
2. How can I get my report so that not all of the fields
print?
To remove Fields from a report, do the following. While
in report change mode, choose <M>enu, <F>ield, <E>rase and
move your cursor to the field to be removed, and press
<Enter>. Save the report with <F2> and print.
3. How do I delete a blank line?
While in the report design or change mode, move the cursor
to the beginning of the line to be deleted and press
<Ctrl><Y>
4. I sorted my table, but when I print my report, the sort
order changes. What is going on?
You have a group in your report. Remove the group band or
add a group band based on the same field as you did your
sort. Groups are reports' way of sorting.
5. Can I use PAL functions in my report?
PAL functions are not allowed in the report generator. If
you need to do calculations that use PAL functions, do
them ahead of time and place the values in fields. Then,
print your report.
6. How do I do three labels across?
Be sure to select labels from the menu, then set the page
width to the width of each label. Insert or delete pages
so that the number of pages equals the number of labels
across.
7. How can I do labels on an HP LaserJet?
Press <Ctrl><V> to toggle on line numbers to the left of
the screen. Delete blank lines in the report header, page
header, page footer, and report footer. The number of
lines between the form bands should match the number of
lines that can be printed on a label. Set the page length
to 60 lines. Select the setup string for "HP LaserJet"
through <S>etting, <S>etup, <P>redefined.
8. How do I put variables on my report?
Two methods are possible. Create a new table with an "A1"
key field and any number of additional fields. Link this
table to the table you are designing the report to through
<F>ield, <P>lace, <L>ookup. Place the other fields from
the linked table. Now, you can add values into the one
record table before you print the report.
The other option is to have your script go into the report
design by using <R>eport, <C>hange, <Tablename>,
<ReportNumber>, <Enter>. Then, move to the position for
the variable and place the variable by using the TYPEIN
command. (ie. TYPEIN variablename.)
9. Is there any way to print a different font?
To use different fonts in a report, you must know the
control code (setup string) your printer used to invoke
the font (usually in the printer manual appendix). Then,
for a whole report, from the Report menu choose
<S>ettings, <S>etup, <C>ustom, <LPT1> (or appropriate) and
type in the appropriate string. ie. \015 for condensed
on an IBM printer.
10. Why won't my fields wordwrap?
If you already selected Wordwrap from the menu, be sure to
reformat the field width of the field you are trying to
wrap. You must shrink the field so it fits within one
page. Select from the menu, <F>ield, <R>eformat and move
to the appropriate field and press <Enter>. Use the left
arrow to resize the field.
11. In a 1 to Many report, when I try to link in the detail
table, the menu lists the wrong keys to link by. Why?
You must design the report from the "Many" side of the
relationship. Start the report design from the detail
table and link in the master table.
- 2 -
12. All of my records from my master are not printing?
Only records that have matching links in all lookup tables
will be included in the report.
13. How can I link two detail tables to a master table in a
report?
As long as the two detail tables have a common field, a
query can be used to merge the tables together. Add the
appropriate keys to the answer table and design the report
linking in the master.
14. How can I do percent in my report?
You must first do a query using a calc sum placing the
total in each field. You can then place a calculated
field in your report that uses this summary field.
15. Why is my report printing a blank page at the end of my
report?
Look in the upper right corner and make sure it reads
"1/1". If it reads 1/n (where n is any number other that
1), you have extra pages in your report. Select
<S>ettings, <P>ageLayout, <D>elete, <OK> until it reads
1/1.
16. How do I get an overall total in my report?
Place the overall summary field in the report footer.
Placing the field in any other band will cause inaccurate
results.
17. On my LaserJet, why am I getting a left arrow at the end
of the report?
Paradox uses a Control-Z character to mark the end of the
report. The font you are using accepts this as a valid
character. Either use the default font or use a font that
does not use this character as a printable character.
18. Some of my values seem inaccurate when I print. What
could be causing this?
Use the Custom Configuration program to set blanks to
Zero. From the menu in the Custom Configuration program,
select <D>efaults, <B>lanks=0, <Yes>.
- 3 -
19. How do I do a field squeeze outside of my form band?
Use <F>ield, <P>lace, <C>alculated and enter [Field1] + "
" + [Field2].
- 4 -